Performance evaluation is a key issue for designers and users of DatabaseManagement Systems (DBMSs). Performance is generally assessed with softwarebenchmarks that help, e.g., test architectural choices, compare differenttechnologies or tune a system. In the particular context of data warehousingand On-Line Analytical Processing (OLAP), although the Transaction ProcessingPerformance Council (TPC) aims at issuing standard decision-support benchmarks,few benchmarks do actually exist. We present in this chapter the Data WarehouseEngineering Benchmark (DWEB), which allows generating various ad-hoc syntheticdata warehouses and workloads. DWEB is fully parameterized to fulfill variousdata warehouse design needs. However, two levels of parameterization keep itrelatively easy to tune. We also expand on our previous work on DWEB bypresenting its new Extract, Transform, and Load (ETL) feature as well as itsnew execution protocol. A Java implementation of DWEB is freely availableon-line, which can be interfaced with most existing relational DMBSs. To thebest of our knowledge, DWEB is the only easily available, up-to-date benchmarkfor data warehouses.
展开▼
